:Base sqlguide.HLP
1 SQL guide
2 Introduction=SQL_Help
1 Selecting records
2 Selecting records - the basics=Selecting_records_the_basics
2 Calculated fields and renaming column titles=Calculated_fields_and_renaming_column_titles
2 Applying a sort order=Applying_a_sort_order
2 Selecting top records only=Selecting_top_records_only
2 Applying a condition=Applying_a_condition
2 Numeric comparisons=Numeric_comparisons
2 Date comparisons=Date_comparisons
2 Text comparisons=Text_comparisons
2 Wildcards=Wildcards
2 Selecting blank entries=Selecting_blank_entries
1 Grouping records
2 Groups and aggregate functions=Groups_and_aggregate_functions
2 Grouping on more than one level=Grouping_on_more_than_one_level
2 Finding duplicate records=Finding_duplicate_records
1 Crosstabs
2 Crosstabulations=Crosstabulations
2 Restricting pivot field values=Restricting_pivot_field_values
1 Relating tables
2 Relational links and joins=Relational_links_and_joins
2 Join types=Join_types
2 Unmatched queries=Unmatched_queries
1 Modifying records
2 Editing records=Editing_records
2 Updating records=Updating_records
2 Adding records=Adding_records
2 Adding multiple records=Adding_multiple_records
2 Creating tables from existing data=Creating_tables_from_existing_data
2 Deleting Records=Deleting_Records
1 Appendix - example data
2 Employee table=Employee_table
2 EmployeeSales table=EmployeeSales_table
2 Holiday table=Holiday_table